Microsoft Access provides several means for opening its database files. Each method has its advantages and disadvantages, and the technique that you should use may depend on how your data is set up. Below is a description of how to open Access data from Crystal Reports through the DAO engine. Another technique uses Microsoft's Open Database Connectivity (ODBC) standard, and is described in Access.
Crystal Reports has been designed to open dBASE data simply and directly through the xBase engine (inside P2bxbse.dll). FoxPro and Clipper are dBASE compatible database formats, and Crystal Reports uses the same DLL to access files created by any of these three DBMS applications.
Note: The P2bxbse.dll translation layer supports FoxPro files up through version 2.6. See Visual FoxPro for versions after 2.6.
The file P2bxbse.dll handles all translation between Crystal Reports and the dBASE, FoxPro, or Clipper files. Each database file contains only a single database table, but there is no limit to the number of files that can be accessed by a report.
Note: dBASE data can also be accessed through the Borland Database Engine (BDE) using the translation file P2bbde.dll. To see how the BDE communicates with database data, see Paradox. The BDE, however, does not support FoxPro or Clipper data.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |